Pandas Profiling Report

Dataset statistics

Number of variables	25
Number of observations	17000
Missing cells	856
Missing cells (%)	0.2%
Duplicate rows	3
Duplicate rows (%)	< 0.1%
Total size in memory	3.2 MiB
Average record size in memory	200.0 B

Variable types

NUM	13
CAT	11
BOOL	1

Warnings

Dataset has 3 (< 0.1%) duplicate rows	Duplicates
`Hotel_Address` has a high cardinality: 1365 distinct values	High cardinality
`Review_Date` has a high cardinality: 731 distinct values	High cardinality
`Hotel_Name` has a high cardinality: 1364 distinct values	High cardinality
`Negative_Review` has a high cardinality: 11586 distinct values	High cardinality
`Positive_Review` has a high cardinality: 14193 distinct values	High cardinality
`Tags` has a high cardinality: 7413 distinct values	High cardinality
`days_since_review` has a high cardinality: 731 distinct values	High cardinality
`Review` has a high cardinality: 16727 distinct values	High cardinality
`Travel_type` has 556 (3.3%) missing values	Missing
`Reviewer_Nationality` is uniformly distributed	Uniform
`Review` is uniformly distributed	Uniform
`Review_Total_Negative_Word_Counts` has 4270 (25.1%) zeros	Zeros
`Review_Total_Positive_Word_Counts` has 1350 (7.9%) zeros	Zeros
`Review_sent` has 3948 (23.2%) zeros	Zeros
`Positive_Review_sent` has 456 (2.7%) zeros	Zeros
`Negative_Review_sent` has 705 (4.1%) zeros	Zeros

Reproduction

Analysis started	2020-12-09 14:56:02.817926
Analysis finished	2020-12-09 14:56:34.042330
Duration	31.22 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

Hotel_Address
Categorical

HIGH CARDINALITY

Distinct	1365
Distinct (%)	8.0%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

27 Devonshire Terrace Westminster Borough London W2 3DP United Kingdom	88
Scarsdale Place Kensington Kensington and Chelsea London W8 5SY United Kingdom	85
225 Edgware Road Westminster Borough London W2 1JU United Kingdom	83
372 Strand Westminster Borough London WC2R 0JJ United Kingdom	76
Great Cumberland Place Westminster Borough London W1H 7DL United Kingdom	75
Other values (1360)	16593

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
27 Devonshire Terrace Westminster Borough London W2 3DP United Kingdom	88	0.5%
Scarsdale Place Kensington Kensington and Chelsea London W8 5SY United Kingdom	85	0.5%
225 Edgware Road Westminster Borough London W2 1JU United Kingdom	83	0.5%
372 Strand Westminster Borough London WC2R 0JJ United Kingdom	76	0.4%
Great Cumberland Place Westminster Borough London W1H 7DL United Kingdom	75	0.4%
30 Leinster Gardens Bayswater Westminster Borough London W2 3AN United Kingdom	73	0.4%
163 Marsh Wall Docklands Tower Hamlets London E14 9SJ United Kingdom	67	0.4%
Piazza Duca D Aosta 4 6 Central Station 20124 Milan Italy	66	0.4%
Delflandlaan 15 Slotervaart 1062 EA Amsterdam Netherlands	66	0.4%
Bryanston Street Marble Arch Westminster Borough London W1H 7EH United Kingdom	65	0.4%
Other values (1355)	16256	95.6%

Frequencies of value counts

Unique

Unique	85 ?
Unique (%)	0.5%

Histogram of lengths of the category

Length

Max length	96
Median length	57
Mean length	58.11417647
Min length	34

Additional_Number_of_Scoring
Real number (ℝ_≥0)

Distinct	469
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	381.1751176
Minimum	5
Maximum	2682
Zeros	0
Zeros (%)	0.0%
Memory size	132.8 KiB

Quantile statistics

Minimum	5
5-th percentile	49
Q1	129
median	256
Q3	482
95-th percentile	1190
Maximum	2682
Range	2677
Interquartile range (IQR)	353

Descriptive statistics

Standard deviation	383.7724891
Coefficient of variation (CV)	1.006814116
Kurtosis	8.43356199
Mean	381.1751176
Median Absolute Deviation (MAD)	151
Skewness	2.472178131
Sum	6479977
Variance	147281.3234
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
211	112	0.7%
228	108	0.6%
256	105	0.6%
391	97	0.6%
74	95	0.6%
387	94	0.6%
325	94	0.6%
493	91	0.5%
101	90	0.5%
207	90	0.5%
Other values (459)	16024	94.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	5	< 0.1%
6	5	< 0.1%
7	4	< 0.1%
8	4	< 0.1%
9	4	< 0.1%

Value	Count	Frequency (%)
2682	67	0.4%
2288	76	0.4%
1936	52	0.3%
1831	85	0.5%
1485	83	0.5%

Review_Date
Categorical

HIGH CARDINALITY

Distinct	731
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

8/2/2017	80
9/15/2016	76
4/5/2017	66
10/27/2015	56
8/14/2016	55
Other values (726)	16667

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
8/2/2017	80	0.5%
9/15/2016	76	0.4%
4/5/2017	66	0.4%
10/27/2015	56	0.3%
8/14/2016	55	0.3%
3/29/2016	55	0.3%
9/29/2015	55	0.3%
11/3/2015	54	0.3%
8/18/2015	53	0.3%
8/30/2016	51	0.3%
Other values (721)	16399	96.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	10
Median length	9
Mean length	8.936764706
Min length	8

Average_Score
Real number (ℝ_≥0)

Distinct	33
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.403347059
Minimum	6.4
Maximum	9.8
Zeros	0
Zeros (%)	0.0%
Memory size	132.8 KiB

Quantile statistics

Minimum	6.4
5-th percentile	7.5
Q1	8.1
median	8.4
Q3	8.8
95-th percentile	9.2
Maximum	9.8
Range	3.4
Interquartile range (IQR)	0.7

Descriptive statistics

Standard deviation	0.5322064392
Coefficient of variation (CV)	0.06333267393
Kurtosis	0.2225766328
Mean	8.403347059
Median Absolute Deviation (MAD)	0.3
Skewness	-0.467020344
Sum	142856.9
Variance	0.2832436939
Monotocity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
8.5	1484	8.7%
8.4	1358	8.0%
8.6	1318	7.8%
8.1	1220	7.2%
8.2	1219	7.2%
8.8	1036	6.1%
8.7	1018	6.0%
8.3	993	5.8%
8.9	932	5.5%
9	751	4.4%
Other values (23)	5671	33.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.4	27	0.2%
6.6	12	0.1%
6.7	28	0.2%
6.8	38	0.2%
6.9	56	0.3%

Value	Count	Frequency (%)
9.8	3	< 0.1%
9.6	30	0.2%
9.5	50	0.3%
9.4	231	1.4%
9.3	445	2.6%

Hotel_Name
Categorical

HIGH CARDINALITY

Distinct	1364
Distinct (%)	8.0%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

Park Grand Paddington Court	88
Copthorne Tara Hotel London Kensington	85
Hilton London Metropole	83
Strand Palace Hotel	76
The Cumberland A Guoman Hotel	75
Other values (1359)	16593

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Park Grand Paddington Court	88	0.5%
Copthorne Tara Hotel London Kensington	85	0.5%
Hilton London Metropole	83	0.5%
Strand Palace Hotel	76	0.4%
The Cumberland A Guoman Hotel	75	0.4%
Blakemore Hyde Park	73	0.4%
Britannia International Hotel Canary Wharf	67	0.4%
Glam Milano	66	0.4%
Best Western Premier Hotel Couture	66	0.4%
Amba Hotel Marble Arch	65	0.4%
Other values (1354)	16256	95.6%

Frequencies of value counts

Unique

Unique	85 ?
Unique (%)	0.5%

Histogram of lengths of the category

Length

Max length	60
Median length	23
Mean length	24.61535294
Min length	2

Reviewer_Nationality
Categorical

UNIFORM

Distinct	34
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

Sweden	500
Kuwait	500
South Africa	500
Poland	500
Singapore	500
Other values (29)	14500

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Sweden	500	2.9%
Kuwait	500	2.9%
South Africa	500	2.9%
Poland	500	2.9%
Singapore	500	2.9%
Belgium	500	2.9%
Switzerland	500	2.9%
United States of America	500	2.9%
Israel	500	2.9%
Norway	500	2.9%
Other values (24)	12000	70.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	26
Median length	9
Mean length	10.47058824
Min length	7

Negative_Review
Categorical

HIGH CARDINALITY

Distinct	11586
Distinct (%)	68.2%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

No Negative	4270
Nothing	422
Nothing	122
nothing	77
	43
Other values (11581)	12066

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
No Negative	4270	25.1%
Nothing	422	2.5%
Nothing	122	0.7%
nothing	77	0.5%
	43	0.3%
None	23	0.1%
Small room	23	0.1%
Breakfast	21	0.1%
Location	19	0.1%
none	16	0.1%
Other values (11576)	11964	70.4%

Frequencies of value counts

Unique

Unique	11398 ?
Unique (%)	67.0%

Histogram of lengths of the category

Length

Max length	1951
Median length	40
Mean length	92.18141176
Min length	1

Review_Total_Negative_Word_Counts
Real number (ℝ_≥0)

ZEROS

Distinct	240
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	18.16629412
Minimum	0
Maximum	380
Zeros	4270
Zeros (%)	25.1%
Memory size	132.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	9
Q3	23
95-th percentile	68
Maximum	380
Range	380
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	29.14347291
Coefficient of variation (CV)	1.604260766
Kurtosis	29.68266722
Mean	18.16629412
Median Absolute Deviation (MAD)	9
Skewness	4.304346386
Sum	308827
Variance	849.3420134
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4270	25.1%
2	819	4.8%
6	601	3.5%
7	565	3.3%
3	547	3.2%
5	539	3.2%
4	509	3.0%
9	506	3.0%
8	490	2.9%
10	413	2.4%
Other values (230)	7741	45.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4270	25.1%
2	819	4.8%
3	547	3.2%
4	509	3.0%
5	539	3.2%

Value	Count	Frequency (%)
380	1	< 0.1%
376	1	< 0.1%
375	2	< 0.1%
365	1	< 0.1%
361	1	< 0.1%

Total_Number_of_Reviews
Real number (ℝ_≥0)

Distinct	1061
Distinct (%)	6.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2418.115235
Minimum	59
Maximum	9568
Zeros	0
Zeros (%)	0.0%
Memory size	132.8 KiB

Quantile statistics

Minimum	59
5-th percentile	392
Q1	1057
median	1901
Q3	3342
95-th percentile	6512.4
Maximum	9568
Range	9509
Interquartile range (IQR)	2285

Descriptive statistics

Standard deviation	1814.168768
Coefficient of variation (CV)	0.7502408247
Kurtosis	1.656460075
Mean	2418.115235
Median Absolute Deviation (MAD)	1006
Skewness	1.298354301
Sum	41107959
Variance	3291208.32
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6608	88	0.5%
7105	85	0.5%
6977	83	0.5%
9568	76	0.4%
5180	75	0.4%
6596	73	0.4%
9086	67	0.4%
7371	66	0.4%
8177	66	0.4%
5770	65	0.4%
Other values (1051)	16256	95.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
59	4	< 0.1%
67	6	< 0.1%
69	1	< 0.1%
70	3	< 0.1%
76	1	< 0.1%

Value	Count	Frequency (%)
9568	76	0.4%
9086	67	0.4%
8177	66	0.4%
7586	57	0.3%
7491	52	0.3%

Positive_Review
Categorical

HIGH CARDINALITY

Distinct	14193
Distinct (%)	83.5%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

No Positive	1350
Location	378
location	77
Everything	73
The location	56
Other values (14188)	15066

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
No Positive	1350	7.9%
Location	378	2.2%
location	77	0.5%
Everything	73	0.4%
The location	56	0.3%
Nothing	46	0.3%
Good location	39	0.2%
Great location	35	0.2%
Location	30	0.2%
Breakfast	24	0.1%
Other values (14183)	14892	87.6%

Frequencies of value counts

Unique

Unique	13891 ?
Unique (%)	81.7%

Histogram of lengths of the category

Length

Max length	1955
Median length	54
Mean length	90.05617647
Min length	1

Review_Total_Positive_Word_Counts
Real number (ℝ_≥0)

ZEROS

Distinct	186
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.88029412
Minimum	0
Maximum	373
Zeros	1350
Zeros (%)	7.9%
Memory size	132.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	10
Q3	21
95-th percentile	54
Maximum	373
Range	373
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	21.23786636
Coefficient of variation (CV)	1.258145516
Kurtosis	30.02590695
Mean	16.88029412
Median Absolute Deviation (MAD)	7
Skewness	4.072515925
Sum	286965
Variance	451.0469674
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1350	7.9%
5	982	5.8%
6	929	5.5%
3	865	5.1%
4	838	4.9%
2	834	4.9%
7	805	4.7%
9	683	4.0%
8	663	3.9%
10	619	3.6%
Other values (176)	8432	49.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1350	7.9%
2	834	4.9%
3	865	5.1%
4	838	4.9%
5	982	5.8%

Value	Count	Frequency (%)
373	1	< 0.1%
308	1	< 0.1%
291	1	< 0.1%
289	1	< 0.1%
281	1	< 0.1%

Total_Number_of_Reviews_Reviewer_Has_Given
Real number (ℝ_≥0)

Distinct	126
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9.639470588
Minimum	1
Maximum	315
Zeros	0
Zeros (%)	0.0%
Memory size	132.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	5
Q3	12
95-th percentile	33
Maximum	315
Range	314
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	13.76445716
Coefficient of variation (CV)	1.427926672
Kurtosis	39.78164827
Mean	9.639470588
Median Absolute Deviation (MAD)	4
Skewness	4.538576177
Sum	163871
Variance	189.4602809
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3674	21.6%
2	1768	10.4%
3	1424	8.4%
4	1147	6.7%
5	931	5.5%
6	825	4.9%
7	714	4.2%
8	638	3.8%
9	543	3.2%
10	498	2.9%
Other values (116)	4838	28.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	3674	21.6%
2	1768	10.4%
3	1424	8.4%
4	1147	6.7%
5	931	5.5%

Value	Count	Frequency (%)
315	1	< 0.1%
199	1	< 0.1%
191	1	< 0.1%
173	1	< 0.1%
171	1	< 0.1%

Reviewer_Score
Real number (ℝ_≥0)

Distinct	35
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.234694118
Minimum	2.5
Maximum	10
Zeros	0
Zeros (%)	0.0%
Memory size	132.8 KiB

Quantile statistics

Minimum	2.5
5-th percentile	4.6
Q1	7.5
median	8.8
Q3	9.6
95-th percentile	10
Maximum	10
Range	7.5
Interquartile range (IQR)	2.1

Descriptive statistics

Standard deviation	1.677791833
Coefficient of variation (CV)	0.2037467098
Kurtosis	0.6766519468
Mean	8.234694118
Median Absolute Deviation (MAD)	0.9
Skewness	-1.088897042
Sum	139989.8
Variance	2.814985435
Monotocity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
10	3135	18.4%
9.6	2146	12.6%
9.2	1930	11.4%
8.8	1657	9.7%
8.3	1504	8.8%
7.5	1195	7.0%
7.9	1185	7.0%
7.1	865	5.1%
6.7	681	4.0%
6.3	577	3.4%
Other values (25)	2125	12.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.5	77	0.5%
2.9	68	0.4%
3	2	< 0.1%
3.3	112	0.7%
3.5	6	< 0.1%

Value	Count	Frequency (%)
10	3135	18.4%
9.6	2146	12.6%
9.5	32	0.2%
9.2	1930	11.4%
9	26	0.2%

Tags
Categorical

HIGH CARDINALITY

Distinct	7413
Distinct (%)	43.6%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	68
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	66
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights ']	64
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ']	63
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	59
Other values (7408)	16680

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	68	0.4%
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	66	0.4%
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights ']	64	0.4%
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ']	63	0.4%
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	59	0.3%
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	57	0.3%
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	56	0.3%
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	55	0.3%
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ']	55	0.3%
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ']	55	0.3%
Other values (7403)	16402	96.5%

Frequencies of value counts

Unique

Unique	5253 ?
Unique (%)	30.9%

Histogram of lengths of the category

Length

Max length	213
Median length	105
Mean length	101.7076471
Min length	30

days_since_review
Categorical

HIGH CARDINALITY

Distinct	731
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

1 days	80
322 day	76
120 day	66
646 day	56
354 day	55
Other values (726)	16667

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
1 days	80	0.5%
322 day	76	0.4%
120 day	66	0.4%
646 day	56	0.3%
354 day	55	0.3%
674 day	55	0.3%
492 day	55	0.3%
639 day	54	0.3%
716 day	53	0.3%
338 day	51	0.3%
Other values (721)	16399	96.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	7
Median length	7
Mean length	6.983823529
Min length	6

lat
Real number (ℝ_≥0)

Distinct	1349
Distinct (%)	8.0%
Missing	147
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%

Mean	48.70350193
Minimum	41.3283758
Maximum	52.4001813
Zeros	0
Zeros (%)	0.0%
Memory size	132.8 KiB

Quantile statistics

Minimum	41.3283758
5-th percentile	41.384829
Q1	48.1756283
median	48.8793427
Q3	51.5144004
95-th percentile	52.3702469
Maximum	52.4001813
Range	11.0718055
Interquartile range (IQR)	3.3387721

Descriptive statistics

Standard deviation	3.688259769
Coefficient of variation (CV)	0.07572884131
Kurtosis	-0.3447617847
Mean	48.70350193
Median Absolute Deviation (MAD)	2.6346902
Skewness	-0.9779669749
Sum	820800.118
Variance	13.60326012
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51.5135555	88	0.5%
51.499046	85	0.5%
51.5195688	83	0.5%
51.5110993	76	0.4%
51.514879	75	0.4%
51.5129736	73	0.4%
51.5019097	67	0.4%
52.3511137	66	0.4%
45.4838504	66	0.4%
52.3681299	65	0.4%
Other values (1339)	16109	94.8%
(Missing)	147	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
41.3283758	25	0.1%
41.368437	26	0.2%
41.3703041	8	< 0.1%
41.371308	53	0.3%
41.3725246	6	< 0.1%

Value	Count	Frequency (%)
52.4001813	11	0.1%
52.3924898	10	0.1%
52.3923684	3	< 0.1%
52.3872884	25	0.1%
52.3856494	54	0.3%

lng
Real number (ℝ)

Distinct	1349
Distinct (%)	8.0%
Missing	147
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%

Mean	3.965988724
Minimum	-0.3192925
Maximum	16.4217627
Zeros	0
Zeros (%)	0.0%
Memory size	132.8 KiB

Quantile statistics

Minimum	-0.3192925
5-th percentile	-0.1882164
Q1	-0.1283489
median	2.211756
Q3	4.8943658
95-th percentile	16.3710205
Maximum	16.4217627
Range	16.7410552
Interquartile range (IQR)	5.0227147

Descriptive statistics

Standard deviation	5.207436922
Coefficient of variation (CV)	1.313023633
Kurtosis	0.9047414419
Mean	3.965988724
Median Absolute Deviation (MAD)	2.3683066
Skewness	1.44714942
Sum	66838.80797
Variance	27.1173993
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.180002	88	0.5%
-0.1917073	85	0.5%
-0.170521	83	0.5%
-0.1208673	76	0.4%
-0.1606501	75	0.4%
-0.1837431	73	0.4%
-0.0232208	67	0.4%
4.8411629	66	0.4%
9.2034067	66	0.4%
-0.1565506	65	0.4%
Other values (1339)	16109	94.8%
(Missing)	147	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.3192925	6	< 0.1%
-0.306071	1	< 0.1%
-0.2915052	5	< 0.1%
-0.290706	11	0.1%
-0.2864945	21	0.1%

Value	Count	Frequency (%)
16.4217627	27	0.2%
16.4200957	31	0.2%
16.4133973	11	0.1%
16.4129493	32	0.2%
16.4116997	9	0.1%

Review
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	16727
Distinct (%)	98.4%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

Location. No Negative	41
Everything. Nothing	35
Everything. No Negative	16
location. No Negative	11
Everything . No Negative	11
Other values (16722)	16886

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Location. No Negative	41	0.2%
Everything. Nothing	35	0.2%
Everything. No Negative	16	0.1%
location. No Negative	11	0.1%
Everything . No Negative	11	0.1%
Location. Nothing	10	0.1%
Great location. No Negative	8	< 0.1%
No Positive. No Negative	7	< 0.1%
Great location . No Negative	6	< 0.1%
Everything was perfect . No Negative	6	< 0.1%
Other values (16717)	16849	99.1%

Frequencies of value counts

Unique

Unique	16639 ?
Unique (%)	97.9%

Histogram of lengths of the category

Length

Max length	3231
Median length	123
Mean length	184.2375882
Min length	4

Review_sent
Real number (ℝ)

ZEROS

Distinct	18
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1335000052
Minimum	-0.8000000119
Maximum	0.8999999762
Zeros	3948
Zeros (%)	23.2%
Memory size	132.8 KiB

Quantile statistics

Minimum	-0.8000000119
5-th percentile	-0.6999999881
Q1	0
median	0.1000000015
Q3	0.5
95-th percentile	0.6000000238
Maximum	0.8999999762
Range	1.699999988
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.3807389717
Coefficient of variation (CV)	2.851977206
Kurtosis	-0.1105772972
Mean	0.1335000052
Median Absolute Deviation (MAD)	0.2000000104
Skewness	-0.4567576258
Sum	2269.500088
Variance	0.1449621646
Monotocity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	3948	23.2%
0.6000000238	3411	20.1%
0.1000000015	2065	12.1%
0.200000003	1405	8.3%
0.3000000119	869	5.1%
-0.6999999881	733	4.3%
-0.1000000015	726	4.3%
0.5	686	4.0%
0.400000006	635	3.7%
-0.200000003	604	3.6%
Other values (8)	1918	11.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.8000000119	314	1.8%
-0.6999999881	733	4.3%
-0.6000000238	282	1.7%
-0.5	223	1.3%
-0.400000006	272	1.6%

Value	Count	Frequency (%)
0.8999999762	170	1.0%
0.8000000119	130	0.8%
0.6999999881	126	0.7%
0.6000000238	3411	20.1%
0.5	686	4.0%

Positive_Review_sent
Real number (ℝ)

ZEROS

Distinct	19
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5839235197
Minimum	-0.8999999762
Maximum	0.8999999762
Zeros	456
Zeros (%)	2.7%
Memory size	132.8 KiB

Quantile statistics

Minimum	-0.8999999762
5-th percentile	-0.6999999881
Q1	0.400000006
median	0.8999999762
Q3	0.8999999762
95-th percentile	0.8999999762
Maximum	0.8999999762
Range	1.799999952
Interquartile range (IQR)	0.4999999702

Descriptive statistics

Standard deviation	0.5021722407
Coefficient of variation (CV)	0.8599965986
Kurtosis	1.357222316
Mean	0.5839235197
Median Absolute Deviation (MAD)	0
Skewness	-1.618109622
Sum	9926.699834
Variance	0.2521769594
Monotocity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0.8999999762	8973	52.8%
0.8000000119	1858	10.9%
-0.6999999881	1417	8.3%
0.400000006	850	5.0%
0.6999999881	755	4.4%
0.200000003	516	3.0%
0	456	2.7%
0.6000000238	439	2.6%
0.3000000119	411	2.4%
0.5	380	2.2%
Other values (9)	945	5.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.8999999762	4	< 0.1%
-0.8000000119	64	0.4%
-0.6999999881	1417	8.3%
-0.6000000238	60	0.4%
-0.5	60	0.4%

Value	Count	Frequency (%)
0.8999999762	8973	52.8%
0.8000000119	1858	10.9%
0.6999999881	755	4.4%
0.6000000238	439	2.6%
0.5	380	2.2%

Negative_Review_sent
Real number (ℝ)

ZEROS

Distinct	19
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-0.2768941173
Minimum	-0.8999999762
Maximum	0.8999999762
Zeros	705
Zeros (%)	4.1%
Memory size	132.8 KiB

Quantile statistics

Minimum	-0.8999999762
5-th percentile	-0.8000000119
Q1	-0.6999999881
median	-0.400000006
Q3	0.3000000119
95-th percentile	0.3000000119
Maximum	0.8999999762
Range	1.799999952
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.4705307075
Coefficient of variation (CV)	-1.699316374
Kurtosis	-1.245651457
Mean	-0.2768941173
Median Absolute Deviation (MAD)	0.400000006
Skewness	0.4383320891
Sum	-4707.199995
Variance	0.2213991467
Monotocity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0.3000000119	4467	26.3%
-0.6999999881	3015	17.7%
-0.8000000119	2818	16.6%
-0.6000000238	1543	9.1%
-0.400000006	1175	6.9%
-0.5	838	4.9%
0	705	4.1%
-0.3000000119	487	2.9%
-0.200000003	446	2.6%
-0.1000000015	372	2.2%
Other values (9)	1134	6.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.8999999762	74	0.4%
-0.8000000119	2818	16.6%
-0.6999999881	3015	17.7%
-0.6000000238	1543	9.1%
-0.5	838	4.9%

Value	Count	Frequency (%)
0.8999999762	168	1.0%
0.8000000119	95	0.6%
0.6999999881	74	0.4%
0.6000000238	62	0.4%
0.5	75	0.4%

Travel_type
Categorical

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	556
Missing (%)	3.3%
Memory size	132.8 KiB

leisure	12842
business	3602

Frequencies
Length

Value	Count	Frequency (%)
leisure	12842	75.5%
business	3602	21.2%
(Missing)	556	3.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	8
Median length	7
Mean length	7.081058824
Min length	3

From_Mobile
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

1	9146
0	7854

Common Values
Chart

Value	Count	Frequency (%)
1	9146	53.8%
0	7854	46.2%

N_Persons
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	132.8 KiB

couple	6841
solo	4549
family	3485
group	2125

Frequencies
Length

Value	Count	Frequency (%)
couple	6841	40.2%
solo	4549	26.8%
family	3485	20.5%
group	2125	12.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	6
Median length	6
Mean length	5.339823529
Min length	4

Stayed_Nights
Real number (ℝ_≥0)

Distinct	22
Distinct (%)	0.1%
Missing	6
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	2.823761328
Minimum	1
Maximum	28
Zeros	0
Zeros (%)	0.0%
Memory size	132.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	6
Maximum	28
Range	27
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.884769165
Coefficient of variation (CV)	0.6674675888
Kurtosis	11.65129454
Mean	2.823761328
Median Absolute Deviation (MAD)	1
Skewness	2.247220293
Sum	47987
Variance	3.552354804
Monotocity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
1	4398	25.9%
2	4336	25.5%
3	3724	21.9%
4	2165	12.7%
5	1045	6.1%
6	543	3.2%
7	394	2.3%
8	156	0.9%
9	86	0.5%
10	51	0.3%
Other values (12)	96	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4398	25.9%
2	4336	25.5%
3	3724	21.9%
4	2165	12.7%
5	1045	6.1%

Value	Count	Frequency (%)
28	1	< 0.1%
27	2	< 0.1%
22	1	< 0.1%
19	2	< 0.1%
18	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	Hotel_Address	Additional_Number_of_Scoring	Review_Date	Average_Score	Hotel_Name	Reviewer_Nationality	Negative_Review	Review_Total_Negative_Word_Counts	Total_Number_of_Reviews	Positive_Review	Review_Total_Positive_Word_Counts	Total_Number_of_Reviews_Reviewer_Has_Given	Reviewer_Score	Tags	days_since_review	lat	lng	Review	Review_sent	Positive_Review_sent	Negative_Review_sent	Travel_type	From_Mobile	N_Persons	Stayed_Nights
0	8 Avenue Rapp 7th arr 75007 Paris France	74	7/5/2016	8.9	Derby Alma	United Kingdom	Parking But it s all the same in any city I suppose expensive and rare to find a space Lol	21	509	Cracking view of the tower	7.0	3.0	8.3	[' Leisure trip ', ' Family with young children ', ' Family Suite ', ' Stayed 1 night ', ' Submitted from a mobile device ']	394 day	48.860503	2.300661	Cracking view of the tower . Parking But it s all the same in any city I suppose expensive and rare to find a space Lol	0.2	0.8	-0.2	leisure	1.0	family	1.0
1	Lakeside Way Brent London HA9 0BU United Kingdom	1427	12/14/2016	8.8	Hilton London Wembley	United Kingdom	The second night with X factor personnel staying at the hotel I was denied entry to the hotel as I was wearing jeans and a t shirt and a Santa hat as I had been a guest at the royal Albert hall On my return to the hotel the entrance was cordoned off due to somebody called Sharon Osborn being in the hotel lobby I had to wait over 20 minutes for security to eventually say if you are actually a guest you should have a key card I showed him my key card and eventually he let me in Then once entering the hotel was stopped again by X factor staff wanting to know why I was coming into the hotel I had to show my key card again to prove I was a guest My second evening was ruined by staff at the Hilton Wembley and security staff	152	4305	First night was fine second night was a nightmare as some staff and judges from the X factor were staying in the hotel	25.0	1.0	7.9	[' Leisure trip ', ' Group ', ' Deluxe King Room with Stadium View ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	232 day	51.557696	-0.283526	First night was fine second night was a nightmare as some staff and judges from the X factor were staying in the hotel . The second night with X factor personnel staying at the hotel I was denied entry to the hotel as I was wearing jeans and a t shirt and a Santa hat as I had been a guest at the royal Albert hall On my return to the hotel the entrance was cordoned off due to somebody called Sharon Osborn being in the hotel lobby I had to wait over 20 minutes for security to eventually say if you are actually a guest you should have a key card I showed him my key card and eventually he let me in Then once entering the hotel was stopped again by X factor staff wanting to know why I was coming into the hotel I had to show my key card again to prove I was a guest My second evening was ruined by staff at the Hilton Wembley and security staff	-0.7	-0.7	-0.7	leisure	1.0	group	2.0
2	225 Edgware Road Westminster Borough London W2 1JU United Kingdom	1485	8/30/2016	7.5	Hilton London Metropole	United Kingdom	Rude staff room not ready at 3 30 pm Request early check in and late check out not accept	21	6977	No Positive	0.0	2.0	4.6	[' Leisure trip ', ' Family with young children ', ' King Hilton Guest Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	338 day	51.519569	-0.170521	No Positive. Rude staff room not ready at 3 30 pm Request early check in and late check out not accept	-0.7	-0.7	-0.7	leisure	1.0	family	1.0
3	1 3 Queens Garden Westminster Borough London W2 3BA United Kingdom	1058	5/28/2017	7.7	The Park Grand London Paddington	United Kingdom	No Negative	0	4380	The hotel was perfect for a short stay in the heart of London very conveniently located for Paddington station and the Heathrow Express Highly recommended	27.0	2.0	8.8	[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ']	67 days	51.514218	-0.180903	The hotel was perfect for a short stay in the heart of London very conveniently located for Paddington station and the Heathrow Express Highly recommended . No Negative	0.6	0.9	0.3	leisure	0.0	couple	1.0
4	Via Mauro Macchi 1 Central Station 20124 Milan Italy	65	11/2/2015	8.4	Hotel Mediolanum	United Kingdom	Unfriendly staff	3	885	The furniture	3.0	17.0	5.8	[' Leisure trip ', ' Group ', ' Double or Twin Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	640 day	45.481342	9.203949	The furniture. Unfriendly staff	-0.3	0.1	-0.8	leisure	1.0	group	3.0
5	26 28 Trebovir Rd Kensington and Chelsea London SW5 9NJ United Kingdom	328	9/9/2016	7.5	Mayflower Hotel Apartments	United Kingdom	The quilt bedding had two stains on when i went to reception the did give me another cover leaving me to change the bedding The rooms didn t have air conditioning which we knew about when booking The fan left in our room was no use and the room was like a sauna which wouldn t of been so bad if our window wasn t level with the garden seating so everyone could see in meaning we couldn t really leave the curtains and windows open to deal with the heat issue The floor in the room was incredibly creaky so it made it impossible to get up in the night to go to the bathroom without waking your partner up The hallway flooring was also very creaky also so you could hear people walking past our room to get to theirs	144	2197	Location is brilliant near tube station and cheap for london free wifi The place overall presented very clean and smart	22.0	2.0	6.3	[' Leisure trip ', ' Couple ', ' Deluxe Double Room with Four Poster Bed ', ' Stayed 3 nights ']	328 day	51.491668	-0.194747	Location is brilliant near tube station and cheap for london free wifi The place overall presented very clean and smart . The quilt bedding had two stains on when i went to reception the did give me another cover leaving me to change the bedding The rooms didn t have air conditioning which we knew about when booking The fan left in our room was no use and the room was like a sauna which wouldn t of been so bad if our window wasn t level with the garden seating so everyone could see in meaning we couldn t really leave the curtains and windows open to deal with the heat issue The floor in the room was incredibly creaky so it made it impossible to get up in the night to go to the bathroom without waking your partner up The hallway flooring was also very creaky also so you could hear people walking past our room to get to theirs	0.0	0.9	-0.8	leisure	0.0	couple	3.0
6	52 56 Inverness Terrace Westminster Borough London W2 3LB United Kingdom	545	7/2/2017	8.0	Shaftesbury Hyde Park International	United Kingdom	The luxury room we stayed in the cost 176 per night without breakfast was no bigger than 7ft square it was absolutely ridiculous We had continuous buzzing noise all night and the towel rail was hanging off It was a total rip off	45	2907	Decorating was the only nice part of the room	10.0	2.0	3.3	[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	32 days	51.512397	-0.186124	Decorating was the only nice part of the room. The luxury room we stayed in the cost 176 per night without breakfast was no bigger than 7ft square it was absolutely ridiculous We had continuous buzzing noise all night and the towel rail was hanging off It was a total rip off	-0.6	-0.4	-0.7	leisure	1.0	couple	1.0
7	John M Keynesplein 2 Slotervaart 1066 EP Amsterdam Netherlands	350	12/2/2016	7.9	Dutch Design Hotel Artemis	United Kingdom	should have been a bit more cleaner	8	2167	Nice friendly staff	4.0	3.0	7.5	[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	244 day	52.341789	4.824952	Nice friendly staff. should have been a bit more cleaner	0.1	0.9	-0.7	leisure	1.0	couple	2.0
8	15 Beeston Place Westminster Borough London SW1W 0JW United Kingdom	67	7/7/2017	9.4	The Goring	United Kingdom	No seperate shower cubicle	5	200	Conceirge doorman lovely bar	5.0	1.0	8.8	[' Leisure trip ', ' Couple ', ' Delightful Queen Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	27 days	51.497562	-0.145551	Conceirge doorman lovely bar. No seperate shower cubicle	0.1	0.9	-0.6	leisure	1.0	couple	1.0
9	Excel 2 Festoon Way Royal Victoria Dock Newham London E16 1RH United Kingdom	853	9/15/2016	8.4	DoubleTree By Hilton London Excel	United Kingdom	No Negative	0	2726	Very good and clean	5.0	1.0	7.9	[' Leisure trip ', ' Couple ', ' Deluxe Queen Room with View ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	322 day	51.507377	0.038657	Very good and clean. No Negative	0.6	0.9	0.3	leisure	1.0	couple	2.0

Last rows

	Hotel_Address	Additional_Number_of_Scoring	Review_Date	Average_Score	Hotel_Name	Reviewer_Nationality	Negative_Review	Review_Total_Negative_Word_Counts	Total_Number_of_Reviews	Positive_Review	Review_Total_Positive_Word_Counts	Total_Number_of_Reviews_Reviewer_Has_Given	Reviewer_Score	Tags	days_since_review	lat	lng	Review	Review_sent	Positive_Review_sent	Negative_Review_sent	Travel_type	From_Mobile	N_Persons	Stayed_Nights
16990	Provincialeweg 38 Zuidoost 1108 AB Amsterdam Netherlands	245	1/28/2017	7.5	Golden Tulip Amsterdam Riverside	Czech Republic	No Negative	0	2362	Excellent service and receptive staff	6.0	2.0	10.0	[' Leisure trip ', ' Couple ', ' Standard Twin Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	187 day	52.315453	4.996300	Excellent service and receptive staff. No Negative	0.6	0.9	0.3	leisure	1.0	couple	1.0
16991	Tiefer Graben 14 20 01 Innere Stadt 1010 Vienna Austria	153	2/16/2016	8.9	Hotel Das Tigra	Czech Republic	No Negative	0	1817	the stuff was nice and helfull	7.0	5.0	10.0	[' Leisure trip ', ' Family with young children ', ' Comfort Double Room ', ' Stayed 1 night ']	534 day	48.212177	16.368077	the stuff was nice and helfull. No Negative	0.5	0.8	0.3	leisure	0.0	family	1.0
16992	Rec Comtal 16 18 Ciutat Vella 08003 Barcelona Spain	211	2/24/2017	8.8	Catalonia Born	Czech Republic	Pillows	2	2094	Breakfast Location	3.0	14.0	9.6	[' Business trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ']	160 day	41.389692	2.179866	Breakfast Location. Pillows	0.1	0.2	0.0	business	0.0	couple	2.0
16993	Via Lentasio 3 Milan City Center 20122 Milan Italy	172	5/28/2017	7.7	Best Western Hotel Ascot	Czech Republic	No Negative	0	1741	Very friendly and helpful personal	6.0	18.0	9.2	[' Business trip ', ' Solo traveler ', ' Standard Single Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	67 days	45.458014	9.191368	Very friendly and helpful personal. No Negative	0.6	0.9	0.3	business	1.0	solo	2.0
16994	59 Leinster Square Kensington and Chelsea London W2 4PS United Kingdom	337	6/10/2017	7.6	New Linden Hotel	Czech Republic	Extremely small room Continental breakfast Uncomfortable bed	9	2820	Quiet street in a good lovation	7.0	15.0	4.6	[' Business trip ', ' Solo traveler ', ' Standard Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	54 days	51.513383	-0.192662	Quiet street in a good lovation. Extremely small room Continental breakfast Uncomfortable bed	0.1	0.9	-0.6	business	1.0	solo	2.0
16995	Delflandlaan 15 Slotervaart 1062 EA Amsterdam Netherlands	947	8/31/2015	8.7	Best Western Premier Hotel Couture	Czech Republic	Minibar not working Parking lot is not free	9	8177	Overall cleanness Good location New furnishings Nespresso in the room	11.0	2.0	9.6	[' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 4 nights ']	703 day	52.351114	4.841163	Overall cleanness Good location New furnishings Nespresso in the room. Minibar not working Parking lot is not free	0.0	0.7	-0.7	leisure	0.0	couple	4.0
16996	Rooseveltplatz 15 09 Alsergrund 1090 Vienna Austria	165	5/3/2016	8.4	Hotel Regina	Czech Republic	single room is really small and I do not believe it is 4 limited breakfast	16	1948	perfect location	3.0	12.0	6.7	[' Business trip ', ' Solo traveler ', ' Single Room ', ' Stayed 2 nights ']	457 day	48.216334	16.359554	perfect location. single room is really small and I do not believe it is 4 limited breakfast	0.1	0.9	-0.7	business	0.0	solo	2.0
16997	152 Cricklewood Broadway Cricklewood London NW2 3ED United Kingdom	512	11/30/2015	8.0	Clayton Crown Hotel London	Czech Republic	it was little bit cold inside of our room and the only temperature regulation device was from A C which did not realy heat Wifi signal was very weak in our room We had to go to the lobby to be well conneceted from neighboring rooms you here more than you wish Noise isolation is weak	58	2491	we were very happy with kind hotel stuff very good connection to public transportation hotel is nice clean and stylish even you need to pay extra for breakfast it is worth money it costs Wide breakfast offer should satisfy everyone even I wrote some negatives in general we can recommend this hotel and we will probably consider this hotel again for our next stay in London	68.0	11.0	8.3	[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 5 nights ']	612 day	51.556155	-0.214182	we were very happy with kind hotel stuff very good connection to public transportation hotel is nice clean and stylish even you need to pay extra for breakfast it is worth money it costs Wide breakfast offer should satisfy everyone even I wrote some negatives in general we can recommend this hotel and we will probably consider this hotel again for our next stay in London . it was little bit cold inside of our room and the only temperature regulation device was from A C which did not realy heat Wifi signal was very weak in our room We had to go to the lobby to be well conneceted from neighboring rooms you here more than you wish Noise isolation is weak	0.0	0.9	-0.7	leisure	0.0	couple	5.0
16998	Pelzgasse 1 15 Rudolfsheim F nfhaus 1150 Vienna Austria	37	3/13/2017	8.3	Arthotel ANA Westbahn	Czech Republic	No Negative	0	450	i love everything I have done a lot of traveling through Europe and this is the best hotel I have found so far	25.0	1.0	10.0	[' Leisure trip ', ' Solo traveler ', ' Single Room ', ' Stayed 1 night ']	143 day	48.197951	16.336318	i love everything I have done a lot of traveling through Europe and this is the best hotel I have found so far . No Negative	0.6	0.9	0.3	leisure	0.0	solo	1.0
16999	Taborstra e 12 02 Leopoldstadt 1020 Vienna Austria	404	10/31/2016	9.1	Hotel Stefanie	Czech Republic	Our room on the street side was bit noisy especially when trams were going Extra charge for parking in the hotel	23	3883	Good location within walking distance to the centre including Prater Friendly staff Great restaurant called Mochi next to the hotel	22.0	2.0	8.3	[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ']	276 day	48.214277	16.380178	Good location within walking distance to the centre including Prater Friendly staff Great restaurant called Mochi next to the hotel . Our room on the street side was bit noisy especially when trams were going Extra charge for parking in the hotel	0.0	0.6	-0.7	leisure	0.0	couple	2.0

Most frequent

	Hotel_Address	Additional_Number_of_Scoring	Review_Date	Average_Score	Hotel_Name	Reviewer_Nationality	Negative_Review	Review_Total_Negative_Word_Counts	Total_Number_of_Reviews	Positive_Review	Review_Total_Positive_Word_Counts	Total_Number_of_Reviews_Reviewer_Has_Given	Reviewer_Score	Tags	days_since_review	lat	lng	Review	Review_sent	Positive_Review_sent	Negative_Review_sent	Travel_type	From_Mobile	N_Persons	Stayed_Nights	count
0	167 rue de Rome 17th arr 75017 Paris France	11	10/18/2016	6.8	Villa Eugenie	Israel	No Negative	0	165	the room was very french and beautiful it was good location and I enjoyed to stay there	18.0	1.0	9.2	[' Leisure trip ', ' Couple ', ' Twin Room ', ' Stayed 3 nights ']	289 day	48.887128	2.314205	the room was very french and beautiful it was good location and I enjoyed to stay there. No Negative	0.6	0.9	0.3	leisure	0.0	couple	3.0	2
1	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	2/29/2016	7.9	H tel Concorde Montparnasse	Lebanon	Nothing	3	2515	Nearly everything was perfect	5.0	16.0	9.2	[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	521 day	48.838108	2.318669	Nearly everything was perfect. Nothing	0.2	0.9	-0.4	leisure	1.0	couple	3.0	2
2	40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France	228	9/22/2015	7.9	H tel Concorde Montparnasse	Lebanon	The wifi is horrible Always something is needed in the room and it takes 24 hours before you can get it Room service is bad I ve asked for a bottle of water it came without glasses tray or ic	41	2515	The location is half an hour walking to saint germain and the staff is friendly	16.0	3.0	7.5	[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	681 day	48.838108	2.318669	The location is half an hour walking to saint germain and the staff is friendly. The wifi is horrible Always something is needed in the room and it takes 24 hours before you can get it Room service is bad I ve asked for a bottle of water it came without glasses tray or ic	0.0	0.7	-0.7	leisure	1.0	couple	1.0	2

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent